EASY30HED1 #'EasyCalc 2.0 - Example Worksheet 2 'Other EasyCalc functions: 'Function Example "Result '=@ASIN(0.1) =@ASIN(0.1) '=@ATAN(0.1) =@ATAN(0.1) !'=@AVG(B6:B9) OR =@AVERAGE(B6:B9) =@AVG(B6:B9) '=@CINT(1.4) =@CINT(1.4) '=@COLS(A1:C1) =@COLS(A1:C1) '=@ABS(-50) =@ABS(-50) '=@ACOS(0.1) =@ACOS(0.1) '=@COS(0.7) =@COS(0.7) '=@COSH(0.7) =@COSH(0.7) '=@COUNT(A6:B14) =@COUNT(A6:B14) '=@DATE(95,3,2) =@DATE(95,3,2) '=@EXP(3) =@EXP(3) '=@FALSE =@FALSE '=@FIX(1.7) =@FIX(1.7) %'=@IF(B18=@FALSE, "NOT TRUE", "TRUE") $=@IF(B18=@FALSE, "NOT TRUE", "TRUE") '=@INDEX(A13:B18,1,0) =@INDEX(A13:B18,1,0) '=@INT(1.7) =@INT(1.7) '=@ISNUM(B18) =@ISNUM(B18) '=@ISSTR(B18) =@ISSTR(B18) '=@LINK("STRINGS.CALC>B10") =@LINK("STRINGS.CALC>B14") '<- Press HELP '=@LOG10(5) =@LOG10(5) '=@LOG(2) =@LOG(2) '=@MAX(B21:B27) =@MAX(B21:B27) '=@MIN(B21:B27) =@MIN(B21:B27) '=@MOD(10,3) =@MOD(10,3) '=@NEWVAT(100,1) =@NEWVAT(100,1) '=@NOT(1) =@NOT(1) '=@NOW =@NOW '=@PI '=@RAD(90) =@RAD(90) '=@DEG(1.5707) =@DEG(1.57079632) '=@RAND =@RAND '=@RND(100) =@RND(100) '=@ROWS(A26:B34) =@ROWS(A26:B34) '=@SIGN(-56) =@SIGN(-56) '=@SIN(0.5) =@SIN(0.5) '=@SINH(0.5) =@SINH(0.5) '=@SQR(49) OR =@SQRT(49) =@SQR(49) '=@SUM(B34:B43) =@SUM(B34:B43) '=@TAN(0.5) =@TAN(0.5) '=@TANH(0.5) =@TANH(0.5) '=@TIME(16,43,23) =@TIME(16,43,23) '=@TODAY =@TODAY '=@TRUE =@TRUE '=@VAT(100) =@VAT(100) '[PRESS HELP HERE] STRINGS.CALC needs to be loaded for this to evaluate. If the link worksheet can't be found, then 0 is returned. No error messages are generated unless the string is invalid.NOTE To get detailed information on any function displayed here, press RETURN while over a cell function, then move the cursor over the '@' symbol of the function you are interested in. Then press HELP.PALL